Overview

Dataset info

Number of variables8
Number of observations99072
Missing cells0 (0.0%)
Duplicate rows0 (0.0%)
Total size in memory6.0 MiB
Average record size in memory64.0 B

Variables types

Numeric5
Categorical1
Boolean0
Date1
URL0
Text (Unique)0
Rejected1
Unsupported0

Warnings

city has a high cardinality: 61 distinct values Warning
state has constant value "Karnataka" Rejected

Variables

city
Categorical

Distinct count61
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Bangalore
49939
Channapatna
 
1815
Ramanagaram
 
1318
Other values (58)
46000
ValueCountFrequency (%) 
Bangalore 49939 50.4%
 
Channapatna 1815 1.8%
 
Ramanagaram 1318 1.3%
 
Chitradurga 1308 1.3%
 
Tumkur 1244 1.3%
 
Karwar 1198 1.2%
 
Bijapur 1164 1.2%
 
Challakere 1104 1.1%
 
Kollegal 1104 1.1%
 
Udupi 1096 1.1%
 
Other values (51) 37782 38.1%
 
Max length15
Mean length8.472999435
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

device_id
Numeric

Distinct count6481
Unique (%)6.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean5.588320934e+15
Minimum-9.22106649e+18
Maximum9.21497389e+18
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-9.22106649e+18
5-th percentile-8.587004742e+18
Q1-4.60687483e+18
Median-2.06674354e+16
Q34.840783435e+18
95-th percentile8.396440232e+18
Maximum9.21497389e+18
Range1.843604038e+19
Interquartile range9.447658264e+18

Descriptive statistics

Standard deviation5.393253255e+18
Coef of variation965.0936871
Kurtosis-1.217173548
Mean5.588320934e+15
MAD4.679140497e+18
Skewness-0.02980802377
Sum5.536461316e+20
Variance2.908718067e+37
Memory size774.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-9.22106649e+18 -9.22094867e+18 -9.22005014e+18 -9.21894088e+18 -9.21480889e+18 ... 9.20012831e+18 9.20214188e+18 9.20517454e+18 9.20631418e+18 9.21497389e+18], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-8.610583201e+18 906 0.9%
 
6.218978703e+18 370 0.4%
 
3.723410909e+18 369 0.4%
 
-6.903863102e+18 320 0.3%
 
-3.33391831e+18 307 0.3%
 
4.143944772e+18 278 0.3%
 
7.392201673e+18 271 0.3%
 
-7.109735224e+18 259 0.3%
 
-5.272268728e+17 256 0.3%
 
6.423644613e+18 236 0.2%
 
Other values (6471) 95500 96.4%
 

Minimum 5 values

ValueCountFrequency (%) 
-9.22106649e+18 22 < 0.1%
 
-9.220830859e+18 8 < 0.1%
 
-9.21926942e+18 97 0.1%
 
-9.218612338e+18 6 < 0.1%
 
-9.217193238e+18 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
9.21497389e+18 22 < 0.1%
 
9.208160883e+18 16 < 0.1%
 
9.207308633e+18 13 < 0.1%
 
9.205319726e+18 33 < 0.1%
 
9.205029352e+18 11 < 0.1%
 

df_index
Numeric

Distinct count99072
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3050054.488
Minimum2951416
Maximum3252945
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2951416
5-th percentile2956369.55
Q12976183.75
Median3000951.5
Q33117500.25
95-th percentile3225424.45
Maximum3252945
Range301529
Interquartile range141316.5

Descriptive statistics

Standard deviation90047.51749
Coef of variation0.0295232488
Kurtosis-0.7809861277
Mean3050054.488
MAD78221.16244
Skewness0.7681568081
Sum3.021749982e+11
Variance8108555405
Memory size774.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[2951416. 3000959.5 3001213.5 3001231.5 3001309.5 ... 3248734.5 3248978.5 3248988.5 3249242.5 3252945. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
3113714 1 < 0.1%
 
3119499 1 < 0.1%
 
2968188 1 < 0.1%
 
2966141 1 < 0.1%
 
2972286 1 < 0.1%
 
2970239 1 < 0.1%
 
3215182 1 < 0.1%
 
3056257 1 < 0.1%
 
3193474 1 < 0.1%
 
3121510 1 < 0.1%
 
Other values (99062) 99062 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
2951416 1 < 0.1%
 
2951417 1 < 0.1%
 
2951418 1 < 0.1%
 
2951419 1 < 0.1%
 
2951420 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3252945 1 < 0.1%
 
3252937 1 < 0.1%
 
3252934 1 < 0.1%
 
3252910 1 < 0.1%
 
3252901 1 < 0.1%
 

event_id
Numeric

Distinct count99072
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1648706.211
Minimum20902
Maximum3252946
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20902
5-th percentile259263.45
Q1834466.75
Median1641787.5
Q32448305
95-th percentile3092085.35
Maximum3252946
Range3232044
Interquartile range1613838.25

Descriptive statistics

Standard deviation919263.741
Coef of variation0.5575667363
Kurtosis-1.215030851
Mean1648706.211
MAD797234.4681
Skewness0.02756812681
Sum1.633406217e+11
Variance8.450458255e+11
Memory size774.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 20902. 201979.5 625613. 3252946. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1128414 1 < 0.1%
 
1658856 1 < 0.1%
 
698389 1 < 0.1%
 
1396781 1 < 0.1%
 
720604 1 < 0.1%
 
960537 1 < 0.1%
 
2269288 1 < 0.1%
 
2530010 1 < 0.1%
 
2793596 1 < 0.1%
 
207368 1 < 0.1%
 
Other values (99062) 99062 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
20902 1 < 0.1%
 
21030 1 < 0.1%
 
21088 1 < 0.1%
 
21136 1 < 0.1%
 
21318 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3252946 1 < 0.1%
 
3252937 1 < 0.1%
 
3252881 1 < 0.1%
 
3252880 1 < 0.1%
 
3252855 1 < 0.1%
 

latitude
Numeric

Distinct count6369
Unique (%)6.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean13.73707947
Minimum11.931887
Maximum25.2048
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum11.931887
5-th percentile12.715878
Q113.005586
Median13.048646
Q314.0284
95-th percentile16.80095
Maximum25.2048
Range13.272913
Interquartile range1.022814

Descriptive statistics

Standard deviation1.347772017
Coef of variation0.0981119764
Kurtosis1.462449473
Mean13.73707947
MAD1.054927397
Skewness1.591455731
Sum1360959.937
Variance1.816489409
Memory size774.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[11.931887 11.932398 11.9324525 11.990741 11.9913375 ... 17.9970095 18.001354 18.0133945 18.0180895 25.2048 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
12.715878 906 0.9%
 
12.82238 370 0.4%
 
12.737445 369 0.4%
 
15.984554 317 0.3%
 
14.00437 307 0.3%
 
13.476138 278 0.3%
 
16.228846 271 0.3%
 
13.321003 259 0.3%
 
17.944439 256 0.3%
 
12.738951 236 0.2%
 
Other values (6359) 95503 96.4%
 

Minimum 5 values

ValueCountFrequency (%) 
11.931887 3 < 0.1%
 
11.932395 6 < 0.1%
 
11.932401 21 < 0.1%
 
11.932504 11 < 0.1%
 
11.943384 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
25.2048 3 < 0.1%
 
18.01851 9 < 0.1%
 
18.017669 6 < 0.1%
 
18.014072 20 < 0.1%
 
18.012717 3 < 0.1%
 

longitude
Numeric

Distinct count6353
Unique (%)6.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean77.02816028
Minimum74.130388
Maximum78.371192
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum74.130388
5-th percentile74.881511
Q176.686884
Median77.58214
Q377.626615
95-th percentile77.659622
Maximum78.371192
Range4.240804
Interquartile range0.939731

Descriptive statistics

Standard deviation0.9395412889
Coef of variation0.01219737412
Kurtosis0.8577524562
Mean77.02816028
MAD0.7483953842
Skewness-1.406883894
Sum7631333.895
Variance0.8827378335
Memory size774.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[74.130388 74.132535 74.134836 74.1422135 74.147168 ... 78.3340845 78.350703 78.3631475 78.3683505 78.371192 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
77.209356 906 0.9%
 
74.906026 370 0.4%
 
77.207593 369 0.4%
 
76.224259 320 0.3%
 
76.671906 307 0.3%
 
77.936359 278 0.3%
 
74.881511 271 0.3%
 
76.492793 259 0.3%
 
76.961038 256 0.3%
 
77.338099 236 0.2%
 
Other values (6343) 95500 96.4%
 

Minimum 5 values

ValueCountFrequency (%) 
74.130388 35 < 0.1%
 
74.134682 156 0.2%
 
74.13499 11 < 0.1%
 
74.137444 29 < 0.1%
 
74.13816 41 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
78.371192 33 < 0.1%
 
78.365509 1 < 0.1%
 
78.363502 1 < 0.1%
 
78.362793 12 < 0.1%
 
78.358757 65 0.1%
 

state
Constant

This variable is constant and should be ignored for analysis

Constant valueKarnataka

timestamp
Date

Distinct count89571
Unique (%)90.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Minimum2016-04-30 23:52:24
Maximum2016-05-07 23:59:06
Mini histogram
Histogram
Histogram of 'timestamp' (bins=N)

Correlations

Missing values

Sample

First rows

citydevice_iddf_indexevent_idlatitudelongitudestatetimestamp
0Bangalore-264,981,784,288,946,400.02951416201,975.013.077.6Karnataka2016-05-07 12:09:27
1Bangalore-264,981,784,288,946,400.02951417746,412.013.077.6Karnataka2016-05-07 20:05:03
2Bangalore-264,981,784,288,946,400.029514181,037,329.013.077.6Karnataka2016-05-01 12:20:38
3Bangalore-264,981,784,288,946,400.029514191,826,194.013.077.6Karnataka2016-05-01 12:17:21
4Bangalore-264,981,784,288,946,400.029514203,065,051.013.077.6Karnataka2016-05-06 12:06:14
5Bangalore-264,981,784,288,946,400.029514213,119,547.013.077.6Karnataka2016-05-07 10:16:02
6Bangalore3,920,728,480,131,979,264.02951422202,001.013.077.7Karnataka2016-05-07 12:38:58
7Bangalore3,920,728,480,131,979,264.02951423221,539.013.077.7Karnataka2016-05-04 09:19:27
8Bangalore3,920,728,480,131,979,264.02951424398,164.013.077.7Karnataka2016-05-04 22:23:52
9Bangalore3,920,728,480,131,979,264.02951425591,462.013.077.7Karnataka2016-05-04 23:50:25

Last rows

citydevice_iddf_indexevent_idlatitudelongitudestatetimestamp
99062Tumkur2,713,652,839,033,492,480.032528693,083,860.013.477.2Karnataka2016-05-01 00:37:23
99063Tiptur-3,505,748,720,567,863,808.032528703,085,078.013.376.6Karnataka2016-05-04 08:18:55
99064Sira-1,684,826,609,267,635,712.032528903,120,062.013.876.9Karnataka2016-05-03 11:25:45
99065Mandya-785,046,573,419,645,056.032528923,132,433.012.676.9Karnataka2016-05-02 12:12:25
99066Tumkur-1,403,242,147,935,198,976.032529003,151,964.013.477.2Karnataka2016-05-05 13:08:10
99067Tumkur-1,403,242,147,935,198,976.032529013,154,327.013.477.2Karnataka2016-05-05 14:15:04
99068Krishnarajapura3,804,801,114,025,227,264.032529103,174,661.013.077.8Karnataka2016-05-02 17:21:25
99069Channapatna4,923,097,247,878,223,872.032529343,215,808.012.777.2Karnataka2016-05-03 23:53:01
99070Rabkavi8,033,389,325,581,660,160.032529373,230,874.016.575.2Karnataka2016-05-05 10:06:10
99071Chitradurga6,057,196,279,748,328,448.032529453,241,600.014.376.4Karnataka2016-05-04 17:51:29